﻿Alter Table Supplier add IdentityCard nvarchar(20) default '' not null
Alter Table Supplier add DateOfBirth datetime
Alter Table Supplier add SupplierEmployerPhone nvarchar(20) default '' not null
Alter Table Supplier add SupplierEmployerIdentify nvarchar(20) default '' not null
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Người đại diện' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Supplier', @level2type=N'COLUMN',@level2name=N'SupplierEmployerName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ĐT người đại diện' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Supplier', @level2type=N'COLUMN',@level2name=N'SupplierEmployerPhone'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'CMND Nguoi dai dien' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Supplier', @level2type=N'COLUMN',@level2name=N'SupplierEmployerIdentify'
GO

